Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference


OpenEdge SQL Broker parameters (SQL)

Use the parameters listed in Table 3–15 to control spawned OpenEdge SQL processes when connecting to a OpenEdge SQL server. The parameters are organized alphabetically by syntax.

Table 3–15: SQL Server parameters
Syntax
Parameter
Purpose
-classpath 
SQL Server Java Classpath
Identify the Java classpath to use when starting an SQL server.
-ServerType 
Type of Server to Start

Limit the type of server the broker can start.

-SQLCursors 
SQL Open Cursors
Define the maximum number of cursors open at any one time.
-SQLStack 
SQL Stack Size
Change the size of the SQL stack.
-SQLStmtCache 
SQL Statement Cache
Set the number of statements that can be stored in the SQL cache.
-SQLTempBuff 
SQL Sorting Memory
Define the size in K-bytes of the temporary table buffers in main memory cache.
-SQLTempDisk 
SQL Sorting on Disk

Define the size in K-bytes of the temporary table for backup storage on disk.

-SQLTempPgSize 
SQL Temp Table Data Page

Define the size in K-bytes of the temporary table data page, which is the upper limit of temporary table record size.


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095